Register the Archive Databases for Reporting

Before an older archive database can be used for reporting in PME, it must be registered in the system.

Distributed System Note: Run the script on the Database Server.

To register an archived database for reporting:

1. Run the following script in the SQL Server Management Studio for each archive database:

   USE <Name of Archive Database>
Update Registry set Value ='ION_Data_Archive' where Value = 'ION_Data'

2. Open the PME Reporting Configuration Manager to verify that the archive database is available.

   

The following image shows PME Reporting Configuration Manager after running the script.